SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 60281 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 60281 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137402,367939,457547,825042,176344,290763,500659,388547,982992,65719,51825,203215,167448,873258,923453,518929,689267,424824,207462,381491,963675,314102,38562,33165,633002,185258,654700,1042636,17513,322936,543737,157055,840294,551923,16240,926814,136133,661114,662846,54437,809742,234900,420190,179134,579527,475090,930298,365438,703173,163764,902986,141222,16430,417379,538792,931586,68727,704018,817339,686676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 60281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 60281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]