SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195051 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195051 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846218,832024,523122,146118,345948,282520,105872,959681,101665,791102,965737,652378,318371,786583,504884,207215,12358,283835,1027848,23937,978937,259749,64563,597039,291252,702841,1002411,838263,56498,294023,932155,699506,851305,210511,120413,876205,800238,271439,366860,194122,581981,425286,97483,197790,268067,536221,751324,195651,709134,650289,85203,1024000,481720,828991,226432,110645,291719,98307,251034,535854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]