SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106963 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106963 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018504,593887,280422,838778,26901,264403,656714,155708,287656,938837,264768,699971,265373,37160,509795,947833,963294,105580,64575,341268,644019,538847,249062,456393,701246,453867,827709,236833,127129,753031,1017166,1031964,259830,939490,886246,562733,255494,772878,889517,267661,92141,538911,567474,771519,159004,831361,454649,850224,226980,1027756,488586,614719,927359,730118,645960,528275,705776,939896,59792,99072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]