SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040215 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040215 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286576,67160,23600,761629,878036,872732,261843,502204,990324,494904,638284,753920,137485,33476,232976,568318,897604,922412,997945,803655,259634,104195,580204,394241,683185,499652,220540,412134,184120,226753,604814,800832,516343,905588,651857,673956,523115,242359,321409,284008,722737,53849,382842,445668,784388,543312,823938,88167,984724,289269,768438,708494,809877,44795,225125,644718,588432,295794,1035425,676985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]