SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426185 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426185 [ RunTime:0.002189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429053,180288,897925,656706,182095,748313,477400,596505,654621,1006790,525187,627675,478099,552845,977785,5710,205398,159480,755461,563672,120601,406185,860322,284962,989699,762426,1019514,415991,93149,154459,918861,719170,318895,469198,434581,449974,1028097,12590,489529,572065,551324,788031,745950,397157,242325,364366,369723,417933,857960,989483,243213,164167,597809,539349,627776,279739,17789,500916,829678,372608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001913s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]