SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781876,936421,562128,486168,732580,84197,538053,340053,827797,498059,861411,786736,629003,267030,65641,181606,844425,517201,514691,346759,454769,938714,405452,187030,666757,950017,314280,269695,443418,866445,102425,540035,470523,273971,260320,828973,630479,872016,54271,950326,991215,9932,379268,263402,930988,769564,721379,7157,975912,577775,955927,251950,113860,614567,168634,848170,290224,962964,252183,87144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]