SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389518 LIMIT 1 [ RunTime:0.000976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389518 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206372,312110,314956,182940,429991,804806,36571,354154,283075,119446,106607,354343,113677,455060,717897,192845,1047134,800088,960040,560592,574017,589165,927515,50208,377434,337231,654864,922062,730185,481393,396350,22226,280713,982585,366844,470794,375481,110936,904797,533080,324108,883111,849920,402537,103062,531367,318609,870433,193268,140987,453608,893612,185580,882556,894167,682466,806359,1042205,363795,138398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001701s ]