SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141413 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141413 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259446,559492,795180,900364,283320,237484,70493,983371,80459,174556,524847,648783,790475,409877,194465,623867,679846,254363,985582,534707,168652,260391,355072,31358,628239,974178,603155,385803,634344,152366,500842,556425,249096,365714,800390,947380,746529,73510,1018898,281677,708061,611744,786564,747983,922579,431723,283590,1035909,501234,7367,655774,134018,847578,990170,854944,798056,711459,310140,379964,147375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]