SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547523 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547523 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232248,940060,202390,51362,418665,28096,468477,162431,135739,425154,37105,596842,76471,378788,259655,454968,756091,755157,175065,575016,175829,542798,62857,136196,630481,152541,147965,43873,698393,773775,929511,372794,325613,787825,650378,846518,431587,431388,669429,554117,38308,243122,89940,761294,251321,305474,222080,488651,1004000,414111,776630,3425,923965,1007941,290232,311819,5950,305459,693730,799871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]