SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020193 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020193 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536941,517916,528835,371474,1006817,511727,982503,800709,464121,67097,985581,611860,155959,848945,14884,311638,849672,805384,119359,790223,927218,581694,945284,182129,995263,687979,836554,89376,395423,435042,291520,120538,506195,292178,584758,340693,648188,606381,376379,807674,863896,582496,103518,312867,114953,326577,841471,1043528,765655,542069,1009190,851172,671670,450264,548858,251286,600549,72846,294271,64766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]