SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498038 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498038 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033450,309904,219664,40748,373639,220317,61946,74618,549193,344352,549233,682023,123478,862801,474993,883690,920016,131919,403476,123453,273192,854033,385479,35644,412434,465655,582286,829394,622355,21893,15955,855119,571806,563066,1032440,611987,320189,112054,353194,557029,270750,590805,26022,334316,603953,323243,981334,784320,543172,498741,936668,470212,923184,971812,761221,729448,1046227,211333,395270,147254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001175s ]