SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543038 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543038 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400429,604507,422202,740574,233624,33148,826726,274481,144911,380422,509624,275664,814933,86979,197478,627051,574216,10561,925214,192548,913714,934297,755880,270937,273774,361733,593984,204009,332845,305642,779057,867665,257242,768460,713142,614730,303823,627767,52438,636240,336903,724725,590181,210697,293250,652993,76049,786272,966672,961502,304168,385314,405561,374268,10399,649711,123311,743938,121437,1006981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]