SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435568 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435568 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253874,947449,731000,255873,605100,130849,365745,1018536,309018,361612,779348,848270,286545,434914,12098,581291,247869,705730,736047,663836,166012,461534,613047,193377,313779,1014237,418155,135344,342438,358919,39942,791139,369054,1026209,125381,139955,483232,180691,192391,310174,654471,421810,17443,578104,399319,862108,285216,717943,576176,884483,768862,577932,608034,963239,981966,321811,813108,393479,685513,380919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]