SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031125 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031125 [ RunTime:0.002333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (356896,675823,413750,310144,628480,542352,440851,117198,888441,456433,744114,553974,998720,883772,961845,900340,505418,586177,562053,251096,154294,62528,956913,811791,475041,111219,754337,456541,407690,959669,129734,235894,276060,99201,760361,278522,199109,172918,1045253,819447,336480,405414,789953,763078,180748,964976,375175,964411,888107,629445,895509,937847,38750,551635,940871,143347,204323,871945,1024713,913229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]