SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334012 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334012 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929764,464024,840080,207434,503226,13838,572214,468567,1048518,757450,813210,943326,587078,607627,123426,697374,417815,292883,577720,884706,569324,676675,305794,688122,1016058,1334,745209,343759,585651,443136,752615,740575,861032,334683,52534,843681,139261,677027,284635,976668,283834,633602,136913,793364,844662,289579,293578,682804,458650,577802,141437,962873,382910,1022279,101938,675296,264477,162570,424210,500287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002125s ]