SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529384 LIMIT 1 [ RunTime:0.000849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529384 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873672,286580,1029731,793795,102911,413428,685779,143920,662394,856354,602624,283309,840889,577547,481140,479178,916700,590468,915076,154402,57167,847654,461298,83415,75456,584184,787334,1048736,32806,567491,902189,3059,288454,208769,354633,685056,291429,922467,769909,978381,937539,805621,565612,373680,208853,821822,566608,563708,137048,671847,959336,493193,321187,888203,354719,585586,805299,329160,490781,941349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]