SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519385 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519385 [ RunTime:0.002652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13903,270364,272403,181909,298828,511234,537639,982207,728792,963766,545024,13794,845412,359052,192139,795287,574641,753066,718251,370463,24475,139492,564096,804880,544649,898748,409407,527314,872051,265001,493510,420560,432489,51484,807553,793618,92917,810812,750061,809204,145422,321243,947591,254851,188244,27027,38630,447000,744516,212100,790822,161411,465404,282260,704840,305594,10980,260377,808653,832299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]