SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019009 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019009 [ RunTime:0.005921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387777,370348,716757,1013831,133094,869583,654843,202511,543407,813831,296432,298460,755229,504771,516650,933420,835631,146707,99949,487816,509935,985494,1020142,693188,923056,913663,410428,1016715,6159,711696,340974,268679,964846,523356,994029,1032135,181442,639123,299582,134874,857897,810278,1035081,633532,997833,984179,519773,57018,852759,34566,208818,571427,458032,493035,100193,465195,141331,823291,755733,557706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]