SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412890 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412890 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842425,745025,132642,513525,1001421,920631,210766,528367,1041359,900011,598011,813150,709672,588904,119617,354758,206001,308345,431757,100880,919690,499554,340243,1022583,714804,407364,1015353,599919,846597,1022846,830437,837235,685914,731782,585320,13354,773433,492482,676560,246884,121889,380754,189026,210524,346184,893439,736448,939296,554435,526510,249158,1003322,79723,564594,650805,563290,238627,710832,839427,997514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]