SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41970 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41970 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039488,199001,903525,715852,143176,441771,1027714,776369,46035,649842,895331,179322,893484,811423,808632,756156,945497,895058,259765,338495,314861,46641,558544,263882,241725,829449,601275,532279,415270,897741,155138,132012,94544,350810,543619,780725,718951,431024,684597,110404,302673,579788,830103,766413,365606,436341,650117,792246,288711,43498,599106,693831,562154,444526,582190,147833,65392,224781,190797,949801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]