SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455315 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455315 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505140,413091,822153,381246,53226,69442,529507,715155,879923,982322,455760,374420,761161,775135,807942,729855,204320,300794,304488,1018284,50386,771468,48549,486903,614233,268970,680086,110580,1028871,274445,980338,876203,901757,881940,835532,333212,111757,1010414,369928,56639,544682,918813,459577,603422,246676,312430,299989,898066,1041560,193128,428240,790232,1025004,90167,69976,454213,154579,626491,584163,863157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000773s ]