SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506186 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506186 [ RunTime:0.003855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573350,113824,664475,631759,494501,178647,715539,273311,121078,947629,965035,661822,427384,288396,236123,135059,383587,911466,793349,929398,380612,832464,948999,347239,437456,71136,248007,676543,892180,470574,1038025,381399,247217,315921,820795,374827,523624,734764,326931,359840,441328,88563,452082,968549,464007,199022,40209,578090,426984,825636,572150,875562,828776,432228,32592,535753,843603,985550,549716,1037167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]