SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534208 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534208 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259454,380238,505734,489752,619793,909268,740913,667783,122406,884323,208518,291484,229064,442055,756682,737767,748487,772831,867615,98790,848930,91281,319500,735352,185727,877620,426028,71657,114270,881024,391924,813629,149893,5079,817278,986624,745022,32816,923004,13563,711677,1044566,541688,711752,432632,485836,539442,683927,266617,427491,321127,669239,778365,264082,349667,984962,609790,1006665,718518,998102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011863s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002181s ]