SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040370 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040370 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125487,511650,757992,454702,87456,615763,171372,50296,354796,7128,887689,77396,988293,913752,91486,284952,815734,126693,275462,779162,188764,899544,592002,975888,253336,478193,649043,743573,497170,71756,75551,984395,102908,124811,850516,1007904,242890,5786,750940,179756,814332,1037183,925026,804747,224929,120807,53881,546785,709054,433888,1048227,949290,83969,428948,324657,628927,1012239,835167,390445,89059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]