SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501012 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501012 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733593,945586,798674,977971,47369,229816,483946,935219,801512,883924,289475,736512,245984,663720,345973,384389,459413,859986,370519,791214,40628,749522,865074,66134,368275,37766,785327,882720,730960,86696,653083,823420,781866,468248,252536,564850,785526,43574,716604,608485,520291,921587,843593,353445,574411,676698,485588,207878,1027684,879334,661585,553241,461756,943737,680863,322572,300653,575672,699267,722766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]