SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037313 LIMIT 1 [ RunTime:0.000904s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037313 [ RunTime:0.004171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17834,134992,467169,111693,555938,524692,649700,723893,905627,327775,614675,364483,464825,243802,691511,635899,35927,842500,123855,997537,824451,694037,760716,95586,223105,1038190,82914,160992,228471,867679,24593,771843,466828,551712,973291,908796,302679,1003680,712582,810005,846947,487144,646030,498464,985518,804568,190947,803226,25849,51119,557559,268359,517651,360817,177054,331455,590370,392285,185266,318872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]