SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920109 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920109 [ RunTime:0.003308s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694808,430300,67786,785200,883735,239818,132735,428505,286445,924718,321591,132528,687424,39692,379914,696993,545838,571551,934071,606890,123271,978851,85250,416953,1007363,535850,170303,844455,440735,711906,352067,723313,967232,254,656393,469489,376766,980290,126124,971943,246951,491657,1028231,168164,674301,65891,586348,628968,342465,139154,685427,282826,215990,767656,861740,96563,180364,621086,838972,710824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]