SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 231978 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 231978 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894787,1047073,692205,130306,1015686,1045063,58228,195887,18560,959081,844183,419014,455838,688955,246535,336503,293993,453766,1003395,311125,668031,375031,754294,383365,891181,179550,687,411977,766058,591364,251504,766073,936185,824162,27705,601042,905010,1042767,763540,106788,1004198,240920,491106,348528,378449,906361,153537,293866,1002985,1037262,273380,1030533,853769,47885,18230,180754,581071,281412,67064,883952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 231978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 231978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]