SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500390 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500390 [ RunTime:0.001491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545827,510539,941568,163573,564639,504743,715369,997761,341491,44310,606356,57985,431562,939201,752372,224743,387071,391612,470556,881809,141614,673463,581900,405109,192736,427496,855750,207682,601252,716792,323378,225123,394863,195883,683301,263935,452487,378299,290770,208510,655151,691101,791326,891557,751533,852584,206538,9876,249758,554081,478925,775301,611371,347816,75939,315820,355892,704580,473890,656482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500390 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500390 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]