SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046068 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046068 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419155,146454,942877,512772,671055,21151,163694,399510,143653,1022399,409366,474458,404809,833735,333346,1020418,882266,331359,882590,76870,546841,744821,343980,78440,230359,549341,965293,296959,130735,36148,1019131,745352,799421,367179,953075,640078,61384,419056,920803,1001743,798407,688162,718698,587044,581968,95672,72563,735867,25773,478413,769149,215390,1014630,777868,293479,630867,582362,409245,245983,839634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]