SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171518 LIMIT 1 [ RunTime:0.004160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171518 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921808,542452,694034,792900,836193,452012,234316,956169,783936,290771,601969,863413,480787,994807,30246,630845,543279,429354,1036683,687296,386943,208086,711204,354903,1009914,272707,985552,971944,698964,440055,812257,729075,844403,113887,398228,778230,352358,802909,291834,930996,856356,173187,158799,693726,739693,887474,441094,1023962,191897,633995,765792,854558,877191,975588,630891,464469,994003,802752,824812,614755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000365s ]