SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001180 LIMIT 1 [ RunTime:0.003984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001180 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329261,29650,741021,472143,738199,547199,129377,941123,606191,708382,48953,457841,432613,134315,960131,823037,29804,843343,292260,28459,480294,163179,676933,589893,244402,237029,727928,277555,827768,1000402,502810,237308,107294,175493,240338,497713,130900,786986,171583,172159,741938,815257,530086,393809,976472,165567,1030508,478295,899168,502096,168291,556328,126597,995133,357296,414806,128683,732052,1008066,717878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]