SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027154 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027154 [ RunTime:0.002882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318538,114330,668448,274001,258043,717974,637498,89899,847165,868566,1044658,896890,905449,650636,815533,687412,742739,326508,609282,957331,503983,73751,23950,848809,626212,341878,88472,187962,374348,31329,1005910,493659,334529,596152,779421,139061,147680,996356,163354,359816,526686,781985,805311,532098,953459,566272,459271,312473,906537,794596,226793,670229,179849,965764,761578,671609,812015,975674,696782,862064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]