SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514526 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514526 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883857,856984,42236,840273,141506,775022,89533,930076,508041,389943,286918,321411,744758,781102,72965,948525,47005,467504,769974,349412,902308,244272,189819,332358,747922,877102,1037181,484832,857496,230978,100853,19831,245446,821527,561444,744270,410011,91121,194292,194673,420301,386341,730902,213037,840805,590450,213692,561130,293205,114195,611366,883227,642234,824974,428655,1022656,648200,428665,652704,298682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514526 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514526 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]