SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56173 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56173 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416393,596858,395262,1011458,337127,95032,395118,923836,144947,500996,197593,214352,830582,670636,13377,647534,612881,704097,296159,365955,3905,893682,335622,741186,1048658,158994,138435,845782,824389,83358,44040,624924,140889,919715,811909,235534,460595,235173,931840,656244,867244,34946,827092,779334,336135,856457,72606,340506,751487,365144,581833,617442,633258,363091,361529,397811,879911,238839,688835,635726) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]