SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268108 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268108 [ RunTime:0.003050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204116,93652,1022095,141616,828418,952800,382455,896658,286788,597202,905363,894879,212321,829530,220650,1013785,81953,416352,199832,194005,266510,871254,357932,268224,177761,987846,669602,460928,484253,1038195,87340,824459,700991,881753,106519,342564,657800,769463,512940,215059,370602,122163,275118,717416,578942,835170,72224,1005172,235352,849621,763758,786639,1012249,403114,565750,681182,249610,118507,971929,520801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]