SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442623 LIMIT 1 [ RunTime:0.000660s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442623 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62173,220953,981977,930181,902651,368436,82530,838917,705725,245983,344407,682128,54667,424569,558037,457364,704847,869505,151258,691964,592336,95900,12431,263745,845173,1022245,9878,181090,609689,115416,830033,789563,1014562,274761,317749,824757,567683,475495,317673,897932,255207,862798,595589,559082,145776,513476,773715,556790,795461,98284,70086,637859,616000,277706,987379,881877,879310,3977,457905,652925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]