SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043711 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043711 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56555,680604,759028,727971,475985,436461,458455,565385,488750,850489,627389,975263,914939,342336,572343,856120,347293,481748,780916,96344,705023,839431,1013803,387610,382764,267795,22552,826654,255496,356502,216852,646212,863706,955036,245314,834466,162747,264692,216827,55104,765967,659404,842280,3323,218288,1024050,937699,18180,101520,453826,669984,530046,235318,472796,846790,491457,626860,675031,834056,43380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]