SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506020 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506020 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798688,932092,766410,875049,523066,262906,474124,1028130,15996,969646,472629,332031,520269,123109,1008009,452990,800053,236061,11676,1028337,834663,682206,462979,14027,577812,187340,505207,13767,13590,64868,115978,855017,331334,771953,335795,677398,573642,482758,186358,985491,771733,1002838,149940,2,454842,266785,379666,334809,347370,773127,566051,1015294,339249,589447,107344,959631,286755,1032379,928866,751553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001613s ]