SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199916 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199916 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (679616,985803,1013602,132427,12379,275174,370396,2250,422092,400298,895607,509993,542739,560268,852687,794623,808469,585843,803382,1030492,584392,229982,131800,785687,414461,281863,770977,337308,255677,742674,1014206,1022893,389067,1014762,90226,352120,345932,1008727,318890,199037,765488,35292,640901,1046749,880296,693235,865076,778565,479921,1037690,215795,273398,192950,817733,733454,290950,1023109,116272,177590,536728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001288s ]