SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499683 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499683 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835224,591295,926843,406207,1046960,896015,264198,262828,121360,394049,738900,156489,394356,612870,886640,616811,532158,777479,764251,686096,699665,1038042,397310,345335,203347,320580,320164,470398,454884,3828,319071,30418,762320,900159,486643,909314,340395,136815,1029552,756975,597817,546035,284250,688739,122632,409018,409792,117375,713586,255858,765137,1021373,538399,635984,660101,656841,762602,23658,3141,416500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]