SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031442 LIMIT 1 [ RunTime:0.000542s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031442 [ RunTime:0.008780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262591,150516,999661,79853,787078,103606,924859,56265,885451,1019164,828977,659190,330864,126175,191646,966038,96623,562270,380493,292561,314526,1002717,40669,972202,588968,848766,478339,192461,367026,41274,122018,866734,812839,629413,19887,1018392,244310,530729,730541,74888,722625,1007135,458321,277368,817230,1037622,77223,676743,882459,417666,463853,794215,813322,338650,424478,188793,841380,993151,80237,367451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000865s ]