SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004487 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004487 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40391,601120,877811,36168,586937,279008,288574,52929,80793,811666,852242,667367,1037949,141047,44584,510949,330148,185495,733636,853217,895228,375853,493036,60934,236621,878159,88440,177492,29983,1018792,534528,179526,344502,415111,675432,906281,14430,514235,485079,318053,548693,953729,103690,576356,470170,946065,1043730,235735,645250,913061,197793,755055,408202,804958,31827,296632,392498,585691,518043,498806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]