SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005321 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005321 [ RunTime:0.001897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97929,675826,851846,796084,248141,969242,607333,569799,791563,311313,153949,950860,192260,377916,701307,68819,716621,923009,549537,744733,748415,527183,560281,112429,906355,1030672,975191,822230,878117,997389,875215,575888,730578,435974,138917,833249,962873,477266,424039,498189,309685,85201,339578,362493,245599,963817,168446,415520,1041768,691086,132292,917619,938817,140205,918331,815931,923519,338061,754712,941664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]