SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51438 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51438 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896518,210573,681076,66501,686645,786021,797818,783870,944040,338544,201401,179851,618234,121389,128185,428582,546242,406585,880170,544516,727562,470986,364115,813200,909813,677828,673964,827195,1007073,393817,492462,672328,49651,286615,618354,461159,984199,868559,448338,329500,284402,356674,366403,569893,562687,479542,1018677,680975,170855,152286,1024704,34144,1019586,480877,172476,908205,226621,404744,490375,898907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001935s ]