SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538610 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538610 [ RunTime:0.002400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394658,569519,393427,289548,617327,780731,783326,783169,753014,559668,1007472,818349,906284,1024271,180831,152977,304181,834301,734644,104267,797956,935731,117909,974780,19097,218035,866023,787742,509788,1005883,931908,562440,667311,905726,49586,451213,239623,108764,664166,759794,375344,250201,679019,476021,574273,88004,227606,38095,440132,140057,782847,675728,801352,54930,822278,775680,23510,954053,976030,767440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]