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` = 1043458 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043458 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619400,948719,808076,326398,888938,723417,921524,443801,310989,619751,123979,205919,1037333,595135,716421,954163,173562,9561,30864,280026,113067,775887,438284,934878,103436,210831,76449,1033635,785352,532546,137188,910535,392131,587341,213168,105933,436648,274186,951535,836940,584976,929316,656489,106434,814632,112513,104414,273821,218900,421616,274452,950661,200978,100609,616068,190636,682777,1036758,601600,319997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000959s ]