SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101293 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101293 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924125,420514,789170,609676,422264,466983,951363,212947,642493,219867,32660,641577,868383,966779,275699,319083,351680,147717,756120,107335,198648,836839,172382,1048841,411496,460168,214670,784050,419622,429497,1038123,979660,1007386,775881,1047412,168145,943246,603723,10631,1043659,203790,747573,676296,969103,91902,157445,521228,771904,735676,130070,478582,164588,1044518,843873,440972,527420,689622,192030,369270,349649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]