SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002498 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002498 [ RunTime:0.004987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618134,535522,692608,115953,973659,981719,960230,665030,668095,308005,98476,781702,550233,792144,800360,305114,722077,334208,422874,123211,254349,380082,35546,505096,907214,757433,358890,765221,993147,908462,252691,794653,1030848,558330,428794,127887,442820,520006,16974,718734,975398,455030,660933,568020,565989,694525,21403,322549,329730,597043,429248,133527,96728,488009,699352,213668,530994,20766,203660,357929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]