SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550989 LIMIT 1 [ RunTime:0.000511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550989 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836058,1014844,808911,93241,605284,930243,997930,487076,868459,752619,418597,883180,803521,615221,558259,86421,755674,760339,844569,1033159,475340,989993,367769,916677,770180,599085,952964,863901,516458,892669,317993,979484,1017306,291381,643145,931226,152847,5369,566842,673664,786743,1002537,101640,424973,791080,853898,223828,873182,1019600,155071,74982,633590,1028526,817805,620157,676507,264519,471632,312593,390678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550989 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550989 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]