SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971481 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971481 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041382,326278,1012803,705456,456993,1006745,347973,164209,1012779,432893,105789,880885,331126,466767,355668,931794,86195,1023083,459823,4768,418190,368043,395760,109162,982646,121940,174297,133744,975317,939559,9430,409849,770901,116119,806707,71511,543495,819544,238201,126772,316166,297154,345680,184808,488024,65221,559817,415766,936,989106,985907,315139,561536,997934,218823,2567,827106,431675,185010,603910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]