SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500073 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500073 [ RunTime:0.003333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505812,1014752,343511,179785,116045,389119,749983,449234,931613,207760,968750,695738,853432,179322,1024358,873580,411071,661427,566751,445786,422469,113119,1020004,965362,55237,832165,182363,539484,897439,989958,169657,517476,754363,760181,310554,998515,913384,203470,283044,877066,881612,455520,871795,595427,188316,688281,255233,770905,707598,948819,775773,1003228,222533,176053,306294,631618,816166,600123,661031,230456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]