SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421254 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421254 [ RunTime:0.004228s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280405,766347,134999,752056,592923,84246,970683,760410,932719,925325,447866,279693,817860,928707,865246,944837,860382,475088,799750,62479,673978,295564,778696,681623,609111,986566,422581,315348,271178,940202,977893,375059,352668,829684,408677,135161,840482,864290,411085,136654,377348,236613,284983,1048535,941156,283327,676459,947215,1020410,471864,1008960,968925,908307,295161,263512,4590,817904,984454,862570,125166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]