SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526018 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526018 [ RunTime:0.002716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840227,151930,838714,22778,940758,747642,179094,487354,970889,532400,250427,944926,588582,223944,58647,975469,669534,844467,768872,996744,622729,41246,779291,813256,689371,243892,703749,889110,528572,997997,426489,385898,564260,184449,305299,202381,278768,165139,1041864,895507,930383,422932,578265,102861,715147,590579,144029,168783,156140,883079,180507,1022645,563510,381593,371919,455801,681052,640812,742628,1016847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002653s ]