SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104462 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104462 [ RunTime:0.003670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028251,470653,419401,890254,486828,850387,587954,896093,671871,742919,845761,385644,400816,394185,4075,843142,610374,835096,777592,60803,73686,475497,52567,564657,222636,812479,354901,743451,77947,89488,103085,856722,363030,554372,613983,805378,276443,307893,195791,820651,741435,838982,990955,43613,854581,755023,193524,194802,367216,368565,811641,213303,81404,212358,997247,173769,821595,883672,652454,572343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]