SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475303 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475303 [ RunTime:0.001859s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367391,804457,281321,617763,801586,635762,711079,442358,486892,842974,80963,120909,692363,1007293,211387,1009710,561095,38299,229440,629615,163038,83712,399047,495871,926951,364080,883825,288642,1031259,836270,9960,779484,915233,920636,552815,292887,83364,904472,1024945,545654,214993,946039,385738,610197,752693,989380,283739,244052,888870,945220,318478,197349,651276,42581,525743,307521,554669,858301,742187,445962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001644s ]