SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513580 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513580 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238515,382676,272473,1031289,313565,667725,698544,443473,121432,762661,1033386,281295,478486,849741,807903,350592,21560,229298,900673,29500,848364,35711,430421,206940,387726,279347,1026645,1009352,290362,628250,58728,843944,489531,733628,939118,478710,973521,1019128,920236,988068,232215,1001700,923026,43377,1023096,827136,868155,482029,138788,719264,560958,448586,975314,401644,880437,442336,1041716,140047,167146,842128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]