SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110067 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110067 [ RunTime:0.003773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031039,348870,934892,727730,1008083,829839,31441,718110,673444,508176,992972,439369,338173,403245,387521,1039349,78583,761795,972704,775516,516137,350783,698224,247985,897664,453915,747826,358485,739980,769765,733239,830540,772672,282427,173203,269209,305922,665100,456203,258429,505881,33930,429607,491321,277604,829891,825536,323065,962874,400500,948580,919187,911146,637697,333226,998841,8339,365008,873384,234091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]