SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197091 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197091 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318659,135663,842966,19266,405301,377409,672534,897244,724122,508961,580909,818103,105073,575989,795916,1031795,322267,974370,308375,165645,657475,271828,532801,341518,39092,297968,1017799,285167,101625,913333,893287,101946,607647,655027,985136,594961,722058,63005,663344,611884,669562,496955,895383,774596,156900,265509,363125,111061,484352,567824,1027243,1036301,783899,548825,459817,645180,352403,301606,959163,553666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]