SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429697 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429697 [ RunTime:0.002128s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105181,920944,740241,223740,630729,762526,320115,825947,711877,420068,435607,1020751,843614,748494,802976,746265,837799,325149,484642,993520,480724,57160,248995,393417,503364,927360,446505,358144,321989,562198,102369,851723,933649,614332,1018489,492473,408617,678346,272710,5680,230413,831612,692642,264430,645254,761043,382856,133133,403525,126373,609678,632614,344359,619282,295277,905937,929924,796856,241887,955716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]