SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412811 LIMIT 1 [ RunTime:0.001376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412811 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59856,773314,727817,775622,427562,344483,239224,712971,793061,64540,258890,459207,775521,572581,144380,187046,342767,134859,763393,495865,369626,108859,437545,254504,225500,561213,936659,720909,700736,363194,714616,137206,567438,400748,533710,159515,502370,210198,760894,1041986,783531,449832,643306,224831,693806,284229,280893,1040452,126640,8141,183201,323913,692989,427830,738951,350841,896135,399153,890691,782233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]