SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465271 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465271 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403390,658059,490330,426183,8641,275252,972219,758570,576464,914145,723232,953859,357099,858284,532588,214650,622815,130419,235102,952597,433635,663107,785416,309874,443120,626627,642304,100581,282835,560359,619561,727836,357020,851201,147997,427139,360130,462057,747543,983212,804951,435490,310378,631023,144041,968533,1019496,553227,713469,321405,816832,454811,118803,439864,435494,354838,614605,35619,766285,494056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]