SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 959190 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 959190 [ RunTime:0.003536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534758,1045608,445411,101149,142350,936005,153818,56628,661462,159024,37587,235665,1005931,293346,305117,1045483,303407,426201,104916,842580,888928,764292,827224,732274,429507,622206,680669,284984,843264,914214,874856,515417,198648,155347,351359,389502,310437,233203,159844,185911,421109,110148,21282,64035,294756,80819,265299,246343,467792,1919,1022195,384800,111691,243940,105702,740964,853837,156162,927977,839277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 959190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 959190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000918s ]