SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505674 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505674 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819228,710821,587193,817444,996076,758154,122408,523240,786838,577816,803114,107896,704699,990250,771847,868370,463814,483891,674968,346519,278786,643512,936604,127955,226956,766873,989615,145390,402102,820457,903851,186988,582692,513949,815021,398245,956803,925465,526864,401099,934188,428418,376462,498149,365343,259661,351444,712022,895535,174531,569004,55894,375959,655233,705868,81945,85202,315639,264855,881086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]