SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147448 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147448 [ RunTime:0.002125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46303,208298,234256,257858,71162,731184,906879,1003045,1043346,675918,830163,984612,720043,205448,370208,811340,227401,439994,45853,970438,43885,900855,38542,581103,94469,869786,1006060,717832,138121,696897,399917,608952,131243,205665,1030538,112359,74937,933067,255094,458997,978324,245724,405354,606465,28004,721444,47919,880889,1038518,477188,664361,101654,67781,146518,582234,1035823,983309,354049,661596,172194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]