SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003178 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003178 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015572,1045881,208788,346733,897953,740765,415967,25606,103228,813444,273542,19816,843935,197112,905157,61243,753080,587584,77126,543667,201733,880881,988774,575264,702155,1009209,435790,560229,1009123,683927,885415,1013352,501695,909955,4414,31062,1033408,725187,350664,20710,394801,248635,291140,184815,649012,178326,161795,144629,315599,955010,178662,887627,530327,346445,13809,80088,409918,417762,919801,437545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]