SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 362651 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 362651 [ RunTime:0.004148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124603,839131,207060,112552,16155,603122,287374,436471,458412,1021459,1014582,151285,719636,552638,205499,191968,422595,394032,59790,126567,582006,251560,188116,222668,574796,383927,558890,165546,101320,932732,213165,690757,458848,751481,555526,83941,227577,499738,494274,879939,386021,649055,445323,962439,470757,941189,326268,202336,565989,936282,271184,160534,809760,532076,635955,223969,651985,423937,419423,915460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 362651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 362651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]